<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" interactivePageBreakByFrame="true" useStyleVersion="10">
				<modelPath>/content/folder[@name='Packages']/package[@name='Storage and Storage Pool Capacity']/model[@name='model']</modelPath>
				<drillBehavior/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles><CSS value="width:1024px"/></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles><CSS value="background-color:white"/></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;padding-left:24px;background-color:#6198C5"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Chargeback by Business Unit and Application</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:24px;color:#333333"/></style></textItem></contents><style><CSS value="height:36px;background-color:#FBFBFB;padding-left:24px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:1024px"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="height:15px"/></style></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;height:313px"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;height:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Daily Chargeback</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:16px;font-weight:bold;color:rgb(162,158,158)"/></style></textItem></contents><style><CSS value="width:100%;padding-top:5px;padding-bottom:5px;padding-left:5px;height:5%;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Daily Provisioned Cost</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:12px;font-weight:bold;color:rgb(162,158,158)"/></style></textItem></contents><style><CSS value="width:100%;padding-top:10px;padding-bottom:5px;padding-left:5px;height:5%;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><list horizontalPagination="true" name="List1" refQuery="Business Unit Total">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%;font-family:Arial;font-size:12px;color:#333333;height:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none"/></style><contents/></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;border-bottom:1px dotted #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="BusinessUnit"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none"/></style><contents/></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;border-bottom:1px dotted #E1E1E2"/><dataFormat><currencyFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Daily Cost"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents><style><CSS value="width:100%;padding-top:5px;padding-bottom:5px;padding-left:5px;height:90%"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="width:248px"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents/><style><CSS value="border-left:1px solid #E1E1E2"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;height:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Monthly Chargeback</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:16px;font-weight:bold;color:rgb(162,158,158)"/></style></textItem></contents><style><CSS value="width:100%;padding-top:5px;padding-bottom:5px;height:5%;text-align:left;padding-left:5px;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Monthly Provisioned Cost</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:12px;font-weight:bold;color:rgb(162,158,158)"/></style></textItem></contents><style><CSS value="width:100%;padding-top:10px;padding-bottom:5px;padding-left:5px;height:5%;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><list horizontalPagination="true" name="List3" refQuery="Business Unit Total">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%;font-family:Arial;font-size:12px;color:#333333;height:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none"/></style><contents/></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;border-bottom:1px dotted #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="BusinessUnit"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none"/></style><contents/></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;border-bottom:1px dotted #E1E1E2"/><dataFormat><currencyFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Monthly Cost"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents><style><CSS value="width:100%;padding-top:5px;padding-bottom:5px;padding-left:5px;height:90%"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="width:248px"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents/><style><CSS value="border-left:1px solid #E1E1E2"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;height:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Annual Chargeback</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:16px;font-weight:bold;color:rgb(162,158,158)"/></style></textItem></contents><style><CSS value="width:100%;padding-top:5px;padding-bottom:5px;padding-left:5px;height:5%;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Annual Provisioned Cost</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:12px;font-weight:bold;color:rgb(162,158,158)"/></style></textItem></contents><style><CSS value="width:100%;padding-top:10px;padding-bottom:5px;padding-left:5px;height:5%;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><list horizontalPagination="true" name="List5" refQuery="Business Unit Total">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%;height:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none"/></style><contents/></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:left;border-bottom:1px dotted #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="BusinessUnit"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none"/></style><contents/></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:right;border-bottom:1px dotted #E1E1E2"/><dataFormat><currencyFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Annual Cost"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents><style><CSS value="width:100%;padding-top:5px;padding-bottom:5px;padding-left:5px;height:90%"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="width:248px"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents/><style><CSS value="border-left:1px solid #E1E1E2"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;height:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Capacity Breakdown</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:16px;font-weight:bold;color:rgb(162,158,158)"/></style></textItem></contents><style><CSS value="width:100%;padding-top:5px;padding-bottom:5px;padding-left:5px;height:5%;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>By Business Unit</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:12px;font-weight:bold;color:rgb(162,158,158)"/></style></textItem></contents><style><CSS value="width:100%;padding-top:10px;padding-bottom:5px;padding-left:5px;height:5%;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><v2_combinationChart depth="50" maxHotspots="10000" name="Combination Chart1" orientation="horizontal" refQuery="Business Unit Total">
				
				
				
				
				<v2_combinationTypeTooltips/>
				
				<v2_commonAxis>
					<v2_ordinalAxis>
						
						<v2_axisLine lineWeight="0"/>
						<v2_axisLabels>
							<style>
								<defaultStyles>
									<defaultStyle refStyle="al"/>
								</defaultStyles>
							</style>
						</v2_axisLabels>
					</v2_ordinalAxis>
				<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="BusinessUnit"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="BusinessUnit" sortOrder="descending"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
				<v2_topLeftAxis>
					<v2_combinationChartTypes>
						<v2_bar barShape="box">
							
							
						<v2_chartDataLabels labelCollisionMode="fine_stagger"/><v2_solidPalette>
						
					<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#6198C5"><v2_solidColor color="#6198C5"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry>
								<v2_fillEffect defaultColor="#E5B09E">
									<v2_linearGradient gradientAngle="180">
										<v2_gradientColor gradientColor="#E5B09E"/>
										<v2_gradientColor colorPosition="100" gradientColor="#A07B6F"/>
									</v2_linearGradient>
								</v2_fillEffect>
							</v2_solidPaletteEntry><v2_solidPaletteEntry>
								<v2_fillEffect defaultColor="#A1A1AA">
									<v2_linearGradient gradientAngle="180">
										<v2_gradientColor gradientColor="#A1A1AA"/>
										<v2_gradientColor colorPosition="100" gradientColor="#717177"/>
									</v2_linearGradient>
								</v2_fillEffect>
							</v2_solidPaletteEntry><v2_solidPaletteEntry>
								<v2_fillEffect defaultColor="#9DBFE0">
									<v2_linearGradient gradientAngle="180">
										<v2_gradientColor gradientColor="#9DBFE0"/>
										<v2_gradientColor colorPosition="100" gradientColor="#6E869D"/>
									</v2_linearGradient>
								</v2_fillEffect>
							</v2_solidPaletteEntry><v2_solidPaletteEntry>
								<v2_fillEffect defaultColor="#C29ACC">
									<v2_linearGradient gradientAngle="180">
										<v2_gradientColor gradientColor="#C29ACC"/>
										<v2_gradientColor colorPosition="100" gradientColor="#886C8F"/>
									</v2_linearGradient>
								</v2_fillEffect>
							</v2_solidPaletteEntry><v2_solidPaletteEntry>
								<v2_fillEffect defaultColor="#80C1BB">
									<v2_linearGradient gradientAngle="180">
										<v2_gradientColor gradientColor="#80C1BB"/>
										<v2_gradientColor colorPosition="100" gradientColor="#5A8783"/>
									</v2_linearGradient>
								</v2_fillEffect>
							</v2_solidPaletteEntry><v2_solidPaletteEntry>
								<v2_fillEffect defaultColor="#C65F71">
									<v2_linearGradient gradientAngle="180">
										<v2_gradientColor gradientColor="#C65F71"/>
										<v2_gradientColor colorPosition="100" gradientColor="#8B424F"/>
									</v2_linearGradient>
								</v2_fillEffect>
							</v2_solidPaletteEntry><v2_solidPaletteEntry>
								<v2_fillEffect defaultColor="#ECC57C">
									<v2_linearGradient gradientAngle="180">
										<v2_gradientColor gradientColor="#ECC57C"/>
										<v2_gradientColor colorPosition="100" gradientColor="#A58A57"/>
									</v2_linearGradient>
								</v2_fillEffect>
							</v2_solidPaletteEntry><v2_solidPaletteEntry>
								<v2_fillEffect defaultColor="#A08689">
									<v2_linearGradient gradientAngle="180">
										<v2_gradientColor gradientColor="#A08689"/>
										<v2_gradientColor colorPosition="100" gradientColor="#705E60"/>
									</v2_linearGradient>
								</v2_fillEffect>
							</v2_solidPaletteEntry><v2_solidPaletteEntry>
								<v2_fillEffect defaultColor="#B6D994">
									<v2_linearGradient gradientAngle="180">
										<v2_gradientColor gradientColor="#B6D994"/>
										<v2_gradientColor colorPosition="100" gradientColor="#7F9868"/>
									</v2_linearGradient>
								</v2_fillEffect>
							</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette></v2_bar>
					</v2_combinationChartTypes>
					<v2_axis>
						
						<v2_axisLine lineWeight="0"/>
						<v2_axisRange>
							<v2_automaticRange/>
						</v2_axisRange>
						<v2_axisLabels>
							<style>
								<defaultStyles>
									<defaultStyle refStyle="al"/>
								</defaultStyles>
							</style>
						</v2_axisLabels>
						
						
					</v2_axis>
				</v2_topLeftAxis>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="ch"/>
					</defaultStyles>
				<CSS value="width:248px;height:297px;font-family:Arial;color:#333333;border-bottom:1px dotted #E1E1E2"/></style>
				<noDataHandler>
					<contents>
						<block>
							<contents>
								<textItem>
									<dataSource>
										<staticValue>No Data Available</staticValue>
									</dataSource>
									<style>
										<CSS value="padding:10px 18px;"/>
									</style>
								</textItem>
							</contents>
						</block>
					</contents>
				</noDataHandler>
			<v2_defaultChartMeasure refDataItem="Allocated Capacity"><style><dataFormat><numberFormat pattern="  ###,###,### TB"/></dataFormat></style></v2_defaultChartMeasure><XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="width:100%;padding-top:5px;padding-bottom:5px;padding-left:5px;height:90%"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="width:248px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:15px"/></style></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents><textItem><dataSource><staticValue>Chargeback by Business Unit and Application Details</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:16px;font-weight:bold;color:rgb(162,158,158)"/></style></textItem></contents><style><CSS value="padding-top:5px;padding-bottom:10px;padding-left:5px;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:10px"/></style></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents><block>
			<contents><list horizontalPagination="true" name="List2" refQuery="Chargeback Total" rowsPerPage="250">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%;height:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="padding-top:5px;padding-bottom:5px;padding-left:5px;font-family:Arial;font-size:12px;color:#333333;text-align:right;border-top-style:none;border-left-style:none;border-bottom:1px solid #E1E1E2;border-right:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Business Unit"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px dotted #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Business Unit"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="Business Unit"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="padding-top:5px;padding-bottom:5px;padding-left:5px;font-family:Arial;font-size:12px;color:#333333;text-align:right;border-top-style:none;border-left-style:none;border-bottom:1px solid #E1E1E2;border-right:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Application"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px dotted #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Application"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="Application"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="padding-top:5px;padding-bottom:5px;padding-left:5px;font-family:Arial;font-size:12px;color:#333333;text-align:right;border-top-style:none;border-left-style:none;border-bottom:1px solid #E1E1E2;border-right:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Server/VM Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px dotted #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Server/VM Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="padding-top:5px;padding-bottom:5px;padding-left:5px;font-family:Arial;font-size:12px;color:#333333;text-align:right;border-top-style:none;border-left-style:none;border-bottom:1px solid #E1E1E2;border-right:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Tier"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px dotted #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Tier"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="padding-top:5px;padding-bottom:5px;padding-left:5px;font-family:Arial;font-size:12px;color:#333333;text-align:right;border-top-style:none;border-left-style:none;border-bottom:1px solid #E1E1E2;border-right:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Tier Cost/GB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px dotted #E1E1E2"/><dataFormat><currencyFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Tier Cost/GB"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="padding-top:5px;padding-bottom:5px;padding-left:5px;font-family:Arial;font-size:12px;color:#333333;text-align:right;border-top-style:none;border-left-style:none;border-bottom:1px solid #E1E1E2;border-right:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Replication"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px dotted #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Replication"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="padding-top:5px;padding-bottom:5px;padding-left:5px;font-family:Arial;font-size:12px;color:#333333;text-align:right;border-top-style:none;border-left-style:none;border-bottom:1px solid #E1E1E2;border-right:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Allocated Capacity (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px dotted #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Allocated Capacity (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="padding-top:5px;padding-bottom:5px;padding-left:5px;font-family:Arial;font-size:12px;color:#333333;text-align:right;border-top-style:none;border-left-style:none;border-bottom:1px solid #E1E1E2;border-right:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Annual Cost"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px dotted #E1E1E2"/><dataFormat><currencyFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Annual Cost"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="padding-top:5px;padding-bottom:5px;padding-left:5px;font-family:Arial;font-size:12px;color:#333333;text-align:right;border-top-style:none;border-left-style:none;border-bottom:1px solid #E1E1E2;border-right:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Monthly Cost"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px dotted #E1E1E2"/><dataFormat><currencyFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Monthly Cost"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="padding-top:5px;padding-bottom:5px;padding-left:5px;font-family:Arial;font-size:12px;color:#333333;text-align:right;border-top-style:none;border-left-style:none;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Daily Cost"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px dotted #E1E1E2"/><dataFormat><currencyFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Daily Cost"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><listGroups><listGroup refDataItem="Business Unit"><listFooter><listRows><listRow><rowCells><rowCell colSpan="6"><contents><textItem><dataSource><dataItemValue refDataItem="Business Unit"/></dataSource></textItem><textItem><dataSource><staticValue> - </staticValue></dataSource></textItem><textItem><dataSource><staticValue>Total</staticValue></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="of"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;background-color:silver"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Allocated Capacity (GB))"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;background-color:silver"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Annual Cost)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><dataFormat><currencyFormat/></dataFormat><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;background-color:silver"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Monthly Cost)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><dataFormat><currencyFormat/></dataFormat><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;background-color:silver"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Daily Cost)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><dataFormat><currencyFormat/></dataFormat><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;background-color:silver"/></style></rowCell></rowCells></listRow></listRows></listFooter></listGroup><listGroup refDataItem="Application"/></listGroups><listOverallGroup><listFooter><listRows><listRow><rowCells><rowCell colSpan="6"><contents><textItem><dataSource><staticValue>Overall</staticValue></dataSource></textItem><textItem><dataSource><staticValue> - </staticValue></dataSource></textItem><textItem><dataSource><staticValue>Total</staticValue></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="if"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;background-color:silver"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Allocated Capacity (GB))"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="is"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;background-color:silver"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Annual Cost)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="is"/></defaultStyles><dataFormat><currencyFormat/></dataFormat><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;background-color:silver"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Monthly Cost)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="is"/></defaultStyles><dataFormat><currencyFormat/></dataFormat><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;background-color:silver"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Daily Cost)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="is"/></defaultStyles><dataFormat><currencyFormat/></dataFormat><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;background-color:silver"/></style></rowCell></rowCells></listRow></listRows></listFooter></listOverallGroup></list></contents>
		<style><CSS value="width:1024px;height:500px;overflow:auto"/></style></block></contents></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.811Z"/></XMLAttributes><reportName>5.4 Chargeback by Business Unit and Application</reportName><classStyles><classStyle name="ls"><CSS value="border-collapse:collapse"/></classStyle><classStyle name="lt"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-left-style:none;background-color:white;color:black;text-align:left;font-weight:bold;border-bottom:1.5pt solid black"/></classStyle><classStyle name="lc"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="lm"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="lh"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="lf"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="ih"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="if"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="is"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="oh"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="of"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="os"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle></classStyles><queries><query name="Device Summary">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL2" type="passThrough">
			<sqlText>SELECT
	'Physical Servers' AS 'Device',
	COUNT(DISTINCT dwh_inventory.host.id) AS 'Metric'
FROM
	dwh_inventory.host
WHERE
	dwh_inventory.host.active = 1
AND
	dwh_inventory.host.id NOT IN (SELECT dwh_inventory.hv_server.hostId FROM dwh_inventory.hv_server)
UNION
SELECT
	'ESX Servers' AS 'Device',
	COUNT(dwh_inventory.host.id) AS 'Metric'
FROM
	dwh_inventory.hv_server
JOIN
	dwh_inventory.host
ON
	dwh_inventory.hv_server.hostId = dwh_inventory.host.id
AND
	dwh_inventory.host.active = 1
UNION
SELECT
	'Generic Devices' AS 'Device',
	COUNT(dwh_inventory.generic_device.id) AS 'Metric'
FROM
	dwh_inventory.generic_device
UNION
SELECT
	'Virtual Machines' AS 'Device',
	COUNT(dwh_inventory.hv_virtual_machine.id) AS 'Metric'
FROM
	dwh_inventory.hv_virtual_machine
UNION
SELECT
	'Storage Arrays' AS 'Device',
	COUNT(DISTINCT dwh_inventory.storage.id) AS 'Metric'
FROM
	dwh_inventory.storage
WHERE
	dwh_inventory.storage.active = 1
UNION
SELECT
	'Storage Pools' AS 'Device',
	COUNT(DISTINCT dwh_inventory.storage_pool.id) AS 'Metric'
FROM
	dwh_inventory.storage_pool
UNION
SELECT
	'NAS Volumes' AS 'Device',
	COUNT(DISTINCT dwh_inventory.internal_volume.id) AS 'Metric'
FROM
	dwh_inventory.internal_volume
UNION
SELECT
	'SAN Volumes' AS 'Device',
	COUNT(DISTINCT dwh_inventory.volume.id) AS 'Metric'
FROM
	dwh_inventory.volume
UNION
SELECT
	'Datastores' AS 'Device',
	COUNT(DISTINCT dwh_inventory.hv_data_store.id) AS 'Metric'
FROM
	dwh_inventory.hv_data_store
UNION
SELECT
	'Switches' AS 'Device',
	COUNT(DISTINCT dwh_inventory.switch.id) AS 'Metric'
FROM
	dwh_inventory.switch
WHERE
	dwh_inventory.switch.active = 1
AND
	dwh_inventory.switch.npv = 0
UNION
SELECT
	'Licensed Switch Ports' AS 'Device',
	COUNT(DISTINCT dwh_inventory.switch_port.id) AS 'Metric'
FROM
	dwh_inventory.switch_port
JOIN
	dwh_inventory.switch
ON
	dwh_inventory.switch_port.switchId = dwh_inventory.switch.id
AND
	dwh_inventory.switch.npv = 0
AND
	dwh_inventory.switch_port.gbicType &lt;&gt; 'ICL'
AND
	dwh_inventory.switch_port.active = 1
AND
	dwh_inventory.switch_port.status &lt;&gt; 'NOT_LICENSED'
UNION
SELECT 	'Unused Licensed Ports' AS 'Device',
	COUNT(DISTINCT dwh_inventory.switch_port.id) AS 'Metric'
FROM
	dwh_inventory.switch_port
JOIN
	dwh_inventory.switch
ON
	dwh_inventory.switch_port.switchId = dwh_inventory.switch.id
AND
	dwh_inventory.switch.npv = 0
AND
	dwh_inventory.switch_port.gbicType &lt;&gt; 'ICL'
AND
	dwh_inventory.switch_port.active = 1
AND
	dwh_inventory.switch_port.status &lt;&gt; 'NOT_LICENSED'
AND
	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.port_connectivity.portId FROM dwh_inventory.port_connectivity)</sqlText>
		<mdProjectedItems><mdProjectedItem name="Device"/><mdProjectedItem name="Metric"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Device"><expression>[SQL2].[Device]</expression></dataItem><dataItem name="Metric"><expression>[SQL2].[Metric]</expression></dataItem></selection>
		</query><query name="Capacity Summary">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL3" type="passThrough">
			<sqlText>SELECT 	'Raw' AS 'Capacity',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawCapacityMB)/1024/1024, 2) AS 'Metric'
FROM 	
	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	
	dwh_capacity.date_dimension
ON 	
	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	
	dwh_capacity.date_dimension.latest = 1
AND 	
	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
UNION
SELECT 	'Raw Unconfigured' AS 'Capacity',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.unconfiguredRawCapacityMB)/1024/1024, 2) AS 'Metric'
FROM 	
	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	
	dwh_capacity.date_dimension
ON 	
	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	
	dwh_capacity.date_dimension.latest = 1
AND 	
	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
UNION
SELECT 	'Physical Usable' AS 'Capacity',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS 'Metric'
FROM 	
	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	
	dwh_capacity.date_dimension
ON 	
	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	
	dwh_capacity.date_dimension.latest = 1
AND 	
	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
UNION
SELECT 	'Thick Usable' AS 'Capacity',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS 'Metric'
FROM 	
	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN
	dwh_capacity.storage_pool_dimension
ON
	dwh_capacity.storage_and_storage_pool_capacity_fact.storagePoolTk = dwh_capacity.storage_pool_dimension.tk
AND
	dwh_capacity.storage_pool_dimension.thinProvisioningSupported = 0
JOIN 	
	dwh_capacity.date_dimension
ON 	
	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	
	dwh_capacity.date_dimension.latest = 1
AND 	
	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
UNION
SELECT 	'Thin Usable' AS 'Capacity',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS 'Metric'
FROM 	
	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN
	dwh_capacity.storage_pool_dimension
ON
	dwh_capacity.storage_and_storage_pool_capacity_fact.storagePoolTk = dwh_capacity.storage_pool_dimension.tk
AND
	dwh_capacity.storage_pool_dimension.thinProvisioningSupported = 1
JOIN 	
	dwh_capacity.date_dimension
ON 	
	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	
	dwh_capacity.date_dimension.latest = 1
AND 	
	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
UNION
SELECT 	'NAS Provisioned' AS 'Capacity',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS 'Metric'
FROM 	
	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	
	dwh_capacity.date_dimension
ON 	
	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	
	dwh_capacity.date_dimension.latest = 1
AND 	
	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
UNION
SELECT 	'Thick NAS Provisioned' AS 'Capacity',
	ROUND(SUM(dwh_inventory.internal_volume.totalAllocatedCapacityMB)/1024/1024, 0) AS 'Metric'
FROM 	
	dwh_inventory.internal_volume
WHERE
	dwh_inventory.internal_volume.thinProvisioned = 0
UNION
SELECT 	'SAN Provisioned' AS 'Capacity',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS 'Metric'
FROM 	
	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	
	dwh_capacity.date_dimension
ON 	
	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	
	dwh_capacity.date_dimension.latest = 1
AND 	
	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
UNION
SELECT 	'Datastore Allocated' AS 'Capacity',
	ROUND(SUM(dwh_inventory.hv_data_store.capacityMB)/1024/1024, 2) AS 'Metric'
FROM
	dwh_inventory.hv_data_store
UNION
SELECT 	'Datastore Provisioned' AS 'Capacity',
	ROUND(SUM(dwh_inventory.hv_data_store.provisionedCapacityMB)/1024/1024, 2) AS 'Metric'
FROM
	dwh_inventory.hv_data_store</sqlText>
		<mdProjectedItems><mdProjectedItem name="Capacity"/><mdProjectedItem name="Metric"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Capacity"><expression>[SQL3].[Capacity]</expression></dataItem><dataItem name="Metric"><expression>[SQL3].[Metric]</expression></dataItem></selection>
		</query><query name="Risk Summary">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL5" type="passThrough">
			<sqlText>SELECT 	'Orphaned (Configuration) TB' AS 'Risk',
	ROUND(SUM(dwh_capacity.volume_capacity_fact.orphanedCapacityMB)/1024/1024, 0) AS 'Metric'
FROM 	
	dwh_capacity.volume_capacity_fact
WHERE 	
	dwh_capacity.volume_capacity_fact.isOrphaned = 1
UNION
SELECT 	'Total Violations' AS 'Risk',
	COUNT(DISTINCT dwh_inventory.violation.id) AS 'Metric'
FROM
	dwh_inventory.violation
UNION
SELECT 	'Missing Redundancies' AS 'Risk',
	COUNT(*) AS 'Metric'
FROM
	(
	SELECT
		dwh_inventory.violation.id
	FROM
		dwh_inventory.violation
	JOIN
		dwh_inventory.host_adapter
	ON
		dwh_inventory.violation.hostId = dwh_inventory.host_adapter.hostId
	AND
		dwh_inventory.violation.type = 'REDUNDANCY_VIOLATION'
	GROUP BY
		dwh_inventory.violation.id
	HAVING
		COUNT(dwh_inventory.host_adapter.id) &gt; 1
	) X
UNION
SELECT 	'Missing Redundancy TB' AS 'Risk',
	ROUND(SUM(x.capacityMB)/1024/1024, 0) AS 'Metric'
FROM
	(
	SELECT
		dwh_inventory.volume.id,
		dwh_inventory.volume.capacityMB capacityMB
	FROM
		dwh_inventory.violation
	JOIN
		dwh_inventory.host_adapter
	ON
		dwh_inventory.violation.hostId = dwh_inventory.host_adapter.hostId
	AND
		dwh_inventory.violation.type = 'REDUNDANCY_VIOLATION'
	JOIN
		dwh_inventory.volume
	ON
		dwh_inventory.violation.volumeId = dwh_inventory.volume.id
	GROUP BY
		dwh_inventory.volume.id
	HAVING
		COUNT(dwh_inventory.host_adapter.id) &gt; 1
	) X
UNION
SELECT 	'Blocked Hosts' AS 'Risk',
	COUNT(*)
FROM 	(
	SELECT 	DISTINCT 
		dwh_inventory.host.id
	FROM 	
		dwh_inventory.host
	JOIN 	
		dwh_inventory.host_port
	ON 	
		dwh_inventory.host.id = dwh_inventory.host_port.hostId
	WHERE 	
		dwh_inventory.host.id NOT IN (SELECT dwh_inventory.physical_path.hostId FROM dwh_inventory.physical_path)
	AND 	
		dwh_inventory.host.id NOT IN (SELECT dwh_inventory.logical.hostId FROM dwh_inventory.logical)
	AND 	
		dwh_inventory.host_port.id NOT IN (SELECT dwh_inventory.port_connectivity.portId FROM dwh_inventory.port_connectivity)
	) X
UNION
SELECT 	'Thin on Thin Provisioned (%)' AS 'Risk',
	ROUND(SUM(thin.dsGB)/SUM(thin.poolGB)*100, 0) AS 'Metric'
FROM 	(
	SELECT 	dwh_inventory.storage_pool.id poolId,
		ROUND(dwh_inventory.storage_pool.totalAllocatedCapacityMB/1024, 2) poolGB,
		ROUND(SUM(x.dsGB), 2) AS dsGB
	FROM 	dwh_inventory.storage_pool
	JOIN 	(
		SELECT 	dwh_inventory.storage_pool.id poolId,
			dwh_inventory.volume.id volId,
			dwh_inventory.volume.capacityMB/1024 AS volGB,
			SUM(dwh_inventory.hv_data_store.provisionedCapacityMB)/1024 AS dsGB,
			ROUND(SUM(dwh_inventory.hv_data_store.provisionedCapacityMB)/dwh_inventory.volume.capacityMB, 4) AS provPercent
		FROM 	dwh_inventory.storage_pool
		JOIN 	dwh_inventory.volume_in_storage_pool
		ON 	dwh_inventory.volume_in_storage_pool.storagePoolId = dwh_inventory.storage_pool.id
		JOIN 	dwh_inventory.volume
		ON 	dwh_inventory.volume_in_storage_pool.volumeId = dwh_inventory.volume.id
		JOIN 	dwh_inventory.hv_data_store_to_volume
		ON 	dwh_inventory.volume.id = dwh_inventory.hv_data_store_to_volume.volumeId
		JOIN 	dwh_inventory.hv_data_store
		ON 	dwh_inventory.hv_data_store_to_volume.dataStoreId = dwh_inventory.hv_data_store.id
		GROUP BY
			dwh_inventory.volume.id
		UNION
		SELECT 	dwh_inventory.storage_pool.id poolId,
			dwh_inventory.internal_volume.id volId,
			dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024 AS volGB,
			SUM(dwh_inventory.hv_data_store.provisionedCapacityMB)/1024 AS dsGB,
			ROUND(SUM(dwh_inventory.hv_data_store.provisionedCapacityMB)/dwh_inventory.internal_volume.totalAllocatedCapacityMB, 4) AS provPercent
		FROM 	dwh_inventory.storage_pool
		JOIN 	dwh_inventory.internal_volume
		ON 	dwh_inventory.storage_pool.id = dwh_inventory.internal_volume.storagePoolId
		JOIN 	dwh_inventory.hv_data_store_to_internal_volume
		ON 	dwh_inventory.internal_volume.id = dwh_inventory.hv_data_store_to_internal_volume.internalVolumeId
		JOIN 	dwh_inventory.hv_data_store
		ON 	dwh_inventory.hv_data_store_to_internal_volume.dataStoreId = dwh_inventory.hv_data_store.id
		GROUP BY
			dwh_inventory.internal_volume.id
		) X
	ON 	dwh_inventory.storage_pool.id = x.poolId
	GROUP BY
		dwh_inventory.storage_pool.id
	) thin</sqlText>
		<mdProjectedItems><mdProjectedItem name="Risk"/><mdProjectedItem name="Metric"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Risk"><expression>[SQL5].[Risk]</expression></dataItem><dataItem name="Metric"><expression>[SQL5].[Metric]</expression></dataItem></selection>
		</query><query name="Health Summary">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL7" type="passThrough">
			<sqlText>SELECT 	'Datasources' AS 'Health',
	COUNT(DISTINCT 	dwh_inventory.acq_data_source.id) AS 'Metric'
FROM
	dwh_inventory.acq_data_source
UNION
SELECT 	'Remote Acquisition Units' AS 'Health',
	COUNT(DISTINCT 	dwh_inventory.acq_acquisition_unit.id) AS 'Metric'
FROM
	dwh_inventory.acq_acquisition_unit
UNION
SELECT 	'Physical Paths' AS 'Health',
	COUNT(DISTINCT 	dwh_inventory.physical_path.id) AS 'Metric'
FROM
	dwh_inventory.physical_path
UNION
SELECT 	'Masking' AS 'Health',
	COUNT(DISTINCT 	dwh_inventory.volume_mask.id) AS 'Metric'
FROM
	dwh_inventory.volume_mask
UNION
SELECT 	'Mapping' AS 'Health',
	COUNT(DISTINCT 	dwh_inventory.volume_map.id) AS 'Metric'
FROM
	dwh_inventory.volume_map
UNION
SELECT 	'Zoning' AS 'Health',
	COUNT(DISTINCT 	dwh_inventory.zone.id) AS 'Metric'
FROM
	dwh_inventory.zone</sqlText>
		<mdProjectedItems><mdProjectedItem name="Health"/><mdProjectedItem name="Metric"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Health"><expression>[SQL7].[Health]</expression></dataItem><dataItem name="Metric"><expression>[SQL7].[Metric]</expression></dataItem></selection>
		</query><query name="Chargeback Total">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL9" type="passThrough">
			<sqlText>SELECT 	dwh_capacity.business_entity_dimension.businessUnit AS 'Business Unit',
	dwh_capacity.application_dimension.name AS 'Application',
	dwh_capacity.host_dimension.name AS 'Server/VM Name',
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.name
		ELSE 	dwh_capacity.service_level_dimension.name 
	END 	AS 'Tier',
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.cost
		ELSE	dwh_capacity.service_level_dimension.cost 
	END 	AS 'Tier Cost/GB',
	dwh_capacity.chargeback_fact.protectionType AS 'Replication',
	ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024, 2) AS 'Allocated Capacity (GB)',
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024 * dwh_capacity.tier_dimension.cost, 2) 
		ELSE	ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024 * dwh_capacity.service_level_dimension.cost, 2) 
	END 	AS 'Allocated Cost'
FROM 	dwh_capacity.chargeback_fact
JOIN  	dwh_capacity.business_entity_dimension
ON 	dwh_capacity.chargeback_fact.businessEntityTk = dwh_capacity.business_entity_dimension.tk
JOIN 	dwh_capacity.application_dimension
ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
JOIN 	dwh_capacity.host_dimension
ON 	dwh_capacity.chargeback_fact.hostTk = dwh_capacity.host_dimension.tk
AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
JOIN 	dwh_capacity.service_level_dimension
ON 	dwh_capacity.chargeback_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
JOIN 	dwh_capacity.tier_dimension
ON 	dwh_capacity.chargeback_fact.tierTk = dwh_capacity.tier_dimension.tk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.latest = 1
GROUP BY
	dwh_capacity.business_entity_dimension.businessUnit,
	dwh_capacity.application_dimension.tk,
	dwh_capacity.host_dimension.tk,
	dwh_capacity.service_level_dimension.tk,
	dwh_capacity.tier_dimension.tk,
	dwh_capacity.chargeback_fact.protectionType
UNION
SELECT 	dwh_capacity.business_entity_dimension.businessUnit AS 'Business Unit',
	dwh_capacity.application_dimension.name AS 'Application',
	dwh_capacity.vm_dimension.name AS 'Server/VM Name',
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.name
		ELSE 	dwh_capacity.service_level_dimension.name 
	END 	AS 'Tier',
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.cost
		ELSE	dwh_capacity.service_level_dimension.cost 
	END 	AS 'Tier Cost/GB',
	'N/A' AS 'Replication',
	ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024, 2) AS 'Allocated Capacity (GB)',
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024 * dwh_capacity.tier_dimension.cost, 2) 
		ELSE	ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024 * dwh_capacity.service_level_dimension.cost, 2) 
	END 	AS 'Allocated Cost'
FROM 	dwh_capacity.vm_capacity_fact
JOIN 	dwh_capacity.business_entity_dimension
ON 	dwh_capacity.vm_capacity_fact.businessEntityTk = dwh_capacity.business_entity_dimension.tk
JOIN 	dwh_capacity.application_dimension
ON 	dwh_capacity.vm_capacity_fact.applicationTk = dwh_capacity.application_dimension.tk
JOIN 	dwh_capacity.vm_dimension
ON 	dwh_capacity.vm_capacity_fact.vmTk = dwh_capacity.vm_dimension.tk
JOIN 	dwh_capacity.service_level_dimension
ON 	dwh_capacity.vm_capacity_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
JOIN 	dwh_capacity.tier_dimension
ON 	dwh_capacity.vm_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.latest = 1
GROUP BY
	dwh_capacity.business_entity_dimension.businessUnit,
	dwh_capacity.application_dimension.tk,
	dwh_capacity.vm_dimension.tk,
	dwh_capacity.service_level_dimension.tk,
	dwh_capacity.tier_dimension.tk</sqlText>
		<mdProjectedItems><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Application"/><mdProjectedItem name="Server/VM Name"/><mdProjectedItem name="Tier"/><mdProjectedItem name="Tier Cost/GB"/><mdProjectedItem name="Replication"/><mdProjectedItem name="Allocated Capacity (GB)"/><mdProjectedItem name="Allocated Cost"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Business Unit"><expression>[SQL9].[Business Unit]</expression></dataItem><dataItem name="Application"><expression>[SQL9].[Application]</expression></dataItem><dataItem name="Server/VM Name"><expression>[SQL9].[Server/VM Name]</expression></dataItem><dataItem name="Tier"><expression>[SQL9].[Tier]</expression></dataItem><dataItem name="Tier Cost/GB"><expression>[SQL9].[Tier Cost/GB]</expression></dataItem><dataItem name="Replication"><expression>[SQL9].[Replication]</expression></dataItem><dataItem name="Allocated Capacity (GB)"><expression>[SQL9].[Allocated Capacity (GB)]</expression></dataItem><dataItem name="Allocated Cost"><expression>[SQL9].[Allocated Cost]</expression></dataItem><dataItem name="Annual Cost"><expression>[SQL9].[Allocated Cost]/4</expression></dataItem><dataItem name="Monthly Cost"><expression>[Annual Cost]/12</expression></dataItem><dataItem name="Daily Cost"><expression>[Annual Cost]/365</expression></dataItem><dataItemListSummary aggregateMethod="total" name="Total(Allocated Capacity (GB))" refDataItem="Allocated Capacity (GB)"/><dataItemListSummary aggregateMethod="total" name="Total(Allocated Cost)" refDataItem="Allocated Cost"/><dataItemListSummary aggregateMethod="total" name="Total(Annual Cost)" refDataItem="Annual Cost"/><dataItemListSummary aggregateMethod="total" name="Total(Monthly Cost)" refDataItem="Monthly Cost"/><dataItemListSummary aggregateMethod="total" name="Total(Daily Cost)" refDataItem="Daily Cost"/></selection>
		</query><query name="Business Unit Total">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL10" type="passThrough">
			<sqlText>SELECT 	x.BusinessUnit,
	SUM(x.allocatedCost),
	ROUND(SUM(allocatedCapacity)/1024, 0) AS 'Allocated Capacity'
FROM
(
SELECT 	dwh_capacity.business_entity_dimension.businessUnit AS BusinessUnit,
	dwh_capacity.application_dimension.name AS Application,
	dwh_capacity.host_dimension.name AS 'Server/VM Name',
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.name
		ELSE 	dwh_capacity.service_level_dimension.name 
	END 	AS Tier,
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.cost
		ELSE	dwh_capacity.service_level_dimension.cost 
	END 	AS 'Tier Cost/GB',
	dwh_capacity.chargeback_fact.protectionType AS 'Replication',
	ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024, 2) AS allocatedCapacity,
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024 * dwh_capacity.tier_dimension.cost, 2) 
		ELSE	ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024 * dwh_capacity.service_level_dimension.cost, 2) 
	END 	AS allocatedCost
FROM 	dwh_capacity.chargeback_fact
JOIN  	dwh_capacity.business_entity_dimension
ON 	dwh_capacity.chargeback_fact.businessEntityTk = dwh_capacity.business_entity_dimension.tk
JOIN 	dwh_capacity.application_dimension
ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
JOIN 	dwh_capacity.host_dimension
ON 	dwh_capacity.chargeback_fact.hostTk = dwh_capacity.host_dimension.tk
AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
JOIN 	dwh_capacity.service_level_dimension
ON 	dwh_capacity.chargeback_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
JOIN 	dwh_capacity.tier_dimension
ON 	dwh_capacity.chargeback_fact.tierTk = dwh_capacity.tier_dimension.tk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.latest = 1
GROUP BY
	dwh_capacity.business_entity_dimension.businessUnit,
	dwh_capacity.application_dimension.tk,
	dwh_capacity.host_dimension.tk,
	dwh_capacity.service_level_dimension.tk,
	dwh_capacity.tier_dimension.tk,
	dwh_capacity.chargeback_fact.protectionType
UNION
SELECT 	dwh_capacity.business_entity_dimension.businessUnit AS BusinessUnit,
	dwh_capacity.application_dimension.name AS Application,
	dwh_capacity.vm_dimension.name AS 'Server/VM Name',
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.name
		ELSE 	dwh_capacity.service_level_dimension.name 
	END 	AS Tier,
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.cost
		ELSE	dwh_capacity.service_level_dimension.cost 
	END 	AS 'Tier Cost/GB',
	'N/A' AS 'Replication',
	ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024, 2) AS allocatedCapacity,
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024 * dwh_capacity.tier_dimension.cost, 2) 
		ELSE	ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024 * dwh_capacity.service_level_dimension.cost, 2) 
	END 	AS 'Allocated Cost'
FROM 	dwh_capacity.vm_capacity_fact
JOIN 	dwh_capacity.business_entity_dimension
ON 	dwh_capacity.vm_capacity_fact.businessEntityTk = dwh_capacity.business_entity_dimension.tk
JOIN 	dwh_capacity.application_dimension
ON 	dwh_capacity.vm_capacity_fact.applicationTk = dwh_capacity.application_dimension.tk
JOIN 	dwh_capacity.vm_dimension
ON 	dwh_capacity.vm_capacity_fact.vmTk = dwh_capacity.vm_dimension.tk
JOIN 	dwh_capacity.service_level_dimension
ON 	dwh_capacity.vm_capacity_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
JOIN 	dwh_capacity.tier_dimension
ON 	dwh_capacity.vm_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.latest = 1
GROUP BY
	dwh_capacity.business_entity_dimension.businessUnit,
	dwh_capacity.application_dimension.tk,
	dwh_capacity.vm_dimension.tk,
	dwh_capacity.service_level_dimension.tk,
	dwh_capacity.tier_dimension.tk
	) X
GROUP BY
	x.BusinessUnit</sqlText>
		<mdProjectedItems><mdProjectedItem name="BusinessUnit"/><mdProjectedItem name="SUM(x.allocatedCost)"/><mdProjectedItem name="Allocated Capacity"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="BusinessUnit"><expression>[SQL10].[BusinessUnit]</expression></dataItem><dataItem name="SUM(x.allocatedCost)"><expression>[SQL10].[SUM(x.allocatedCost)]</expression></dataItem><dataItem aggregate="total" name="Allocated Capacity"><expression>[SQL10].[Allocated Capacity]</expression></dataItem><dataItem name="Annual Cost"><expression>[SQL10].[SUM(x.allocatedCost)]/4</expression></dataItem><dataItem name="Monthly Cost"><expression>[Annual Cost]/12</expression></dataItem><dataItem aggregate="total" name="Daily Cost"><expression>[Annual Cost]/365</expression></dataItem></selection>
		</query></queries></report>